Tabela Contractor

Definicja tabeli Contractor

Name

Contractor

Code

Contractor

Comment

 


Lista kolumn tabeli Contractor

Name

Code

ContractorID

ContractorID

InsurerID

InsurerID

AddressID

AddressID

ShortName

ShortName

FullName

FullName

StartDT

StartDT

StopDT

StopDT

Contact

Contact

SysID

SysID

Type

Type

TaxPayerID

TaxPayerID

CompanyStatisticalNo

CompanyStatisticalNo

Sender

Sender


Kolumna ContractorID tabeli Contractor

Definicja kolumny ContractorID tabeli Contractor

Name

ContractorID

Code

ContractorID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna InsurerID tabeli Contractor

Definicja kolumny InsurerID tabeli Contractor

Name

InsurerID

Code

InsurerID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna AddressID tabeli Contractor

Definicja kolumny AddressID tabeli Contractor

Name

AddressID

Code

AddressID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ShortName tabeli Contractor

Definicja kolumny ShortName tabeli Contractor

Name

ShortName

Code

ShortName

Data Type

VARCHAR2(50)

Mandatory

No

Comment

 


Kolumna FullName tabeli Contractor

Definicja kolumny FullName tabeli Contractor

Name

FullName

Code

FullName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna StartDT tabeli Contractor

Definicja kolumny StartDT tabeli Contractor

Name

StartDT

Code

StartDT

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna StopDT tabeli Contractor

Definicja kolumny StopDT tabeli Contractor

Name

StopDT

Code

StopDT

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna Contact tabeli Contractor

Definicja kolumny Contact tabeli Contractor

Name

Contact

Code

Contact

Data Type

VARCHAR2(100)

Mandatory

No

Comment

 


Kolumna SysID tabeli Contractor

Definicja kolumny SysID tabeli Contractor

Name

SysID

Code

SysID

Data Type

VARCHAR2(38)

Mandatory

No

Comment

 


Kolumna Type tabeli Contractor

Definicja kolumny Type tabeli Contractor

Name

Type

Code

Type

Data Type

CHAR(1)

Mandatory

No

Comment

 


Kolumna TaxPayerID tabeli Contractor

Definicja kolumny TaxPayerID tabeli Contractor

Name

TaxPayerID

Code

TaxPayerID

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna CompanyStatisticalNo tabeli Contractor

Definicja kolumny CompanyStatisticalNo tabeli Contractor

Name

CompanyStatisticalNo

Code

CompanyStatisticalNo

Data Type

VARCHAR2(15)

Mandatory

No

Comment

 


Kolumna Sender tabeli Contractor

Definicja kolumny Sender tabeli Contractor

Name

Sender

Code

Sender

Data Type

VARCHAR2(16)

Mandatory

No

Comment

Identyfikator swiadczeniodawcy poszczególnych OW NFZ.


Lista kluczy tabeli Contractor

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Contractor

Definicja klucza Identifier_1 tabeli Contractor

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment